// Copyright 2006 - Ricardo Stuven (rstuven@gmail.com)
//
// This file is part of MsSqlSpatial.
// MsSqlSpatial is free software; you can redistribute it and/or modify
// it under the terms of the GNU Lesser General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
// 
// MsSqlSpatial is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU Lesser General Public License for more details.

// You should have received a copy of the GNU Lesser General Public License
// along with MsSqlSpatial; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA 

using System.Data.SqlClient;
using System.Xml;
using Microsoft.SqlServer.Server;
using MsSqlSpatial;

public sealed class Triggers
{
    [SqlTrigger(Name = "ST_DropGeometryTable", Target = "DATABASE", Event = "FOR DROP_TABLE")]
    public static void DropGeometryTableTrigger()
    {
        // Get schema and table names.
        var eventData = new XmlDocument();
        eventData.Load(SqlContext.TriggerContext.EventData.CreateReader());
        string schemaName = eventData.SelectSingleNode("/EVENT_INSTANCE/SchemaName").InnerText;
        string tableName = eventData.SelectSingleNode("/EVENT_INSTANCE/ObjectName").InnerText;

        using (SqlConnection connection = DatabaseHelper.ContextConnection)
        {
            connection.Open();
            using (SqlCommand command = connection.CreateCommand())
            {
                GeometryTable.ExecuteDropTableDependantObjects(command, schemaName, tableName);
            }
        }

        SqlContext.Pipe.Send(string.Format(
                                 @"Geometry table [{0}].[{1}] dropped."
                                 , schemaName, tableName));
    }
}